USE [Finances]
GO
/****** Object:  Table [dbo].[transactions_categories]    Script Date: 09/14/2008 22:01:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[transactions_categories](
	[transaction_id] [uniqueidentifier] NOT NULL,
	[category_id] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[transactions_categories]  WITH CHECK ADD  CONSTRAINT [FK_transactions_categories_categories] FOREIGN KEY([category_id])
REFERENCES [dbo].[categories] ([category_id])
GO
ALTER TABLE [dbo].[transactions_categories] CHECK CONSTRAINT [FK_transactions_categories_categories]
GO
ALTER TABLE [dbo].[transactions_categories]  WITH CHECK ADD  CONSTRAINT [FK_transactions_categories_transactions] FOREIGN KEY([transaction_id])
REFERENCES [dbo].[transactions] ([transaction_id])
GO
ALTER TABLE [dbo].[transactions_categories] CHECK CONSTRAINT [FK_transactions_categories_transactions]